---- 1  


---- ORACLEݿһִ͹ϵ͵ݿ⣬ԴﵽTBݣôα֤ЩݵİȫҪǴ1991꿪ʼʹORACLEݿ⣬ͨЩʹãƶһ׵ORACLEݿıƶȡڰǵıƶȽܸңҲο 


---- 2 ʵҪݿзʽ 


---- ORACLEݿзʽһǹ鵵ʽARCHIVELOG鵵ʽĿǵݿⷢʱ޶Ȼָύǲ鵵ʽ(NOARCHIVELOG)ָݿ⵽Ļյ㡣Ǹݿĸ߿ԺûɳܶʧĹĶ٣ʽеݿΪ鵵ʽЩڿ͵Եݿò鵵ʽ 


---- 3 θıݿзʽ 


---- 31ڴݿʱݿеķʽ 


---- ڴݿʱΪݿһ֣;ݿʼĴ浵ʽһΪNOARCHIVELOGʽݿⴴԺ󣬸ǵҪҪڹ鵵ʽݿĳARCHIVELOGʽ 


---- 32ı䲻鵵ʽΪΪ鵵ʽ 


رݿ⣬е 

ıݿзʽǶݿҪĶҪݿݣԿֵܳ 


Instance ,Mountݿ⵫ݿ⣬ı鵵ʽ 

sqldba lmode=ysvrmgrl 

sqldba>connect internal 

sqldba>startup mount 

sqldba>alter database archivelog; 



ʹԶ浵 

ڳʼļinit*.ora(һORACLEĿ¼²Ŀ¼dbs)Ӳ 

log_archive_start=true 


ָ浵¼ļʹŵλ 

ͬڳʼļinit*.oraмĲ 

log_archive_format=%S.arc 

log_archive_dest=/arch12/arch (arch12 ־ļŵĿ¼) 



رݿ⣬ݿ⣬鵵ʽתɡ 

---- 4 ƶ 

---- 41ݿзʽͿɳܶʧĹݿĻƶȶڲ鵵ʽõORACLEݿ߼Export յƶǣһһȫ(x01.dmp)һһۻ(c*.dmp)һһ(I*.dmp)һݣۻݻȫݣÿ걸ݺԶĻϴ洢ЩݶԶִе,ı 


---- ڹ鵵ʽõORCALEݣݿⴴԺһϵȫݣƽʱڲرݿǰ£һڶԾıļݿļݣݿĽṹı䣬磺ӱռ䣬ļȣػرݿ⣬ݿȫݣ򣬱ݿļļճ־ļдϵģþͱݡ 


---- 4.2յķ 


---- 4.2.1鵵ʽ 


---- AIXϵͳΪ,Զݣ 


---- a.ȽUNIXû demo/demo 


---- b.oracleûµ .profile  demo û£Ա֤ demo û Export 


---- c.rootû¼༭ /var/adm/cron/cron.allow ûdemo,demoûȨԶִݿⱸݵshell 


---- d.ݿⱸݳ򣬷ŵû²Ŀ¼bin£ЩļҪп ִȨļzlbf1:(1һִеĳ) 


. /u11/demo/.profile 

exp system/manager inctype=INCREMENTAL file=i01.dmp 

ftp -n< < ! 

open 10.10.10.40 

user demo demo 

binary 

prompt 

cd backup40 

put i01.dmp 

close 

bye 

! 

ļzlbf2:(2, ڶִеĳ) 

. /u11/demo/.profile 

exp system/manager inctype=INCREMENTAL file=i02.dmp 

ftp -n< < ! 

open 10.10.10.40 

user demo demo 

binary 

prompt 

cd backup40 

put i02.dmp 

close 

bye 

! 

ļzlbf3:(3, ִеĳ) 

. /u11/demo/.profile 

exp system/manager inctype=INCREMENTAL file=i03.dmp 

ftp -n< < ! 

open 10.10.10.40 

user demo demo 

binary 

prompt 

cd backup40 

put i03.dmp 

close 

bye 

! 

ļzlbf4:(4, ִеĳ) 

. /u11/demo/.profile 

exp system/manager inctype=INCREMENTAL file=i04.dmp 

ftp -n< < ! 

open 10.10.10.40 

user demo demo 

binary 

prompt 

cd backup40 

put i04.dmp 

close 

bye 

! 

ļzlbf5:(5, ִеĳ) 

. /u11/demo/.profile 

exp system/manager inctype=INCREMENTAL file=i05.dmp 

ftp -n< < ! 

open 10.10.10.40 

user demo demo 

binary 

prompt 

cd backup40 

put i05.dmp 

close 

bye 

! 

ļzlbf6:(6, ִеĳ) 

. /u11/demo/.profile 

js=`ls c*.dmp|wc -l` 

if test $js = 0 

then 

exp system/manager inctype=CUMULATIVE file=c01.dmp 

ftp -n< < ! 

open 10.10.10.40 

user demo demo 

binary 

prompt 

cd backup40 

put c01.dmp 

close 

bye 

! 

fi 

if test $js = 1 

then 

exp system/manger inctype=CUMULATIVE file=c02.dmp 

ftp -n< < ! 

open 10.10.10.40 

user demo demo 

binary 

prompt 

cd backup40 

put c02.dmp 

close 

bye 

! 

fi 

if test $js = 2 

then 

exp system/maneger inctype=CUMULATIVE file=c03.dmp 

ftp -n< < ! 

open 10.10.10.40 

user demo demo 

binary 

prompt 

cd backup40 

put c03.dmp 

close 

bye 

! 

fi 

if test $js = 3 

then 

exp system/manager inctype=COMPLETE file=x01.dmp 

ftp -n< < ! 

open 10.10.10.40 

user demo demo 

binary 

prompt 

cd backup40 

put x01.dmp 

close 

bye 

! 

rm c*.dmp 

fi 


---- e.demo û½һļ:cron.demo,ļ 

59 22 * * 1 bin/zlbf1 

59 22 * * 2 bin/zlbf2 

59 22 * * 3 bin/zlbf3 

59 22 * * 4 bin/zlbf4 

59 22 * * 5 bin/zlbf5 

59 22 * * 6 bin/zlbf6 


---- f.demoûִ 

crontab cron.demo ִеĽŵ 

/var/spool/cron/crontabs/demoļ 


---- g.cron ̣kill -1 ̺ 

---- h.ִнڱûʼ 


---- i.鿴ǷִУ뿴:/var/adm/cron/logļ 


---- 4.2.2鵵ʽ 


---- a. ҵҪյļ¼ļļͲļ 


---- b. رݿ⣬һȫ(òϵͳTARдshell)Ȼݿ⹩ʹ,shell£ 


tar cvf /dev/rmt/ctape2 /u1/oracle/dbs/ctrl1ora7.ctl\ 

/u1/oracle/dbs/ctrl2ora7.ctl\ 

/u1/oracle/dbs/ctrl3ora7.ctl\ 

/u1/oracle/dbs/systora7.dbf\ 

/u1/oracle/dbs/rbsora7.dbf\ 

/u1/oracle/dbs/tempora7.dbf\ 

/u1/oracle/dbs/toolora7.dbf\ 

/u1/oracle/dbs/usrora7.dbf\ 

/ls1/ls1.dbf\ 

/u1/oracle/dbs/log1ora7.dbf\ 

/u1/oracle/dbs/log2ora7.dbf\ 

/u1/oracle/dbs/log3ora7.dbf 

---- a. ıռļĲֻ 

ȱռյĿʼ 

alter tablespace ռ begin backup; 

òϵͳļ 


ıռս 

alter tablespace ռ end backup 

---- ռһǣǵļһǽ 

---- d. ݿṹıҪĿļ 


sqldba >alter database backup 

controlfile to ļ reuse; 


---- 5  


---- һƵıƶݿⰲȫеϣܵĿɹͬǲο
